I want to set up and learn Laravel following this course
When I try to use the command php artisan migrate I get this error:
[Illuminate\Database\QueryException]
SQLSTATE[HY000] [1045] Access denied for user 'laravel'@'localhost' (using password: NO) (SQL: select * from information_schema.tables whe
re table_schema = laravel and table_name = migrations)
[PDOException]
SQLSTATE[HY000] [1045] Access denied for user 'laravel'@'localhost' (using password: NO)
I have looked for answers. I figured I may have to make some changes in the .env file, but I don't know what, and nothing I have tried so far has worked.
DB_CONNECTION=mysql
DB_HOST=127.0.0.1
DB_PORT=3306
DB_DATABASE=laravel
DB_USERNAME=laravel
DB_PASSWORD=
I'm using Ubuntu 16.04, not a Mac OS X as in the video, so I wonder what should I do differently? Is there some MySQL setting I did not set correctly?
I had the same problem with my plesk ubuntu 18.04 remote server. In your .env file put double quotes around your database password and username then run php artisan config:clear and php artisan cache:clear
DB_CONNECTION=mysql
DB_HOST=127.0.0.1
DB_PORT=3306
DB_DATABASE=dbname
DB_USERNAME="xyz"
DB_PASSWORD="123"
I had never come across this problem before.
You don't have a user named 'laravel'. You should change the DB_USERNAME to the one you're actually using to access your DB. Mostly it's root by default so the changes in .env should be
DB_CONNECTION=mysql
DB_HOST=127.0.0.1
DB_PORT=3306
DB_DATABASE=laravel
DB_USERNAME=root
DB_PASSWORD=
If you are trying to run this command with homestead, you need to make sure you change the values of the following environmental variables within the .env file to:
DB_DATABASE=homestead
DB_USERNAME=homestead
DB_PASSWORD=secret
After you have changed the values, make sure to run the following two commands before you do anything else:
php artisan config:clear
php artisan cache:clear